Using thread-safe database drivers
If you share and refresh reports over the web, open them using thread-safe database drivers whenever possible. The Crystal Report Engine supports multiple threads. Thus, when you make multiple data requests through thread-safe database drivers, the Report Engine can process all of the requests simultaneously. As the result, you'll be able to view your reports sooner.
Currently, the following ODBC drivers for SQL Server and Informix are thread-safe:
- Sqlsrv32.dll (MS SQL Server)
- Crinf13.dll, Crinf14.dll, Crinf913.dll, Crinf914.dll (Merant drivers for Informix).
Further, the following native database drivers are thread-safe:
- p2smon.dll (ADO)
- p2soledb.dll (OLE DB)
- p2sora7.dll (Oracle)
- p2ssyb10.dll (Sybase)
- p2ldb2.dll (DB2).